package com.ruoyi.finance.collection.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.finance.collection.domain.BillCollection;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;

/**
* @author 80661
* @description 针对表【BILL_COLLECTION(收款费项表)】的数据库操作Mapper
* @createDate 2023-07-04 15:02:31
* @Entity generator.domain.BillCollection
*/
public interface BillCollectionMapper extends BaseMapper<BillCollection> {

    //查询一级费目名称 参数 dictValue
    public String selectBasicFeeName(String dictValue);

    //根据订单ID和费率ID查询是否有收款费项
    public BillCollection selectByProjectIdAndRateId(@Param("projectId") Long projectId,@Param("ruleId") Long ruleId);
    

    List<BillCollection> listBillCollectionByStatementId(@Param("statementId")Long statementId);

    boolean updateByStatementId(@Param("statementId") Long statementId);
    
    void updateCollectionStatus(@Param("statementId") Long statementId,@Param("collectionStatus") String collectionStatus);
    
    void updateDelNameAndDelTime(@Param("billCollectionId") Long billCollectionId,@Param("delName") String delName,@Param("delTime") Date delTime);

}




